Green Vocabulary

[insert_php] global $wpdb; $cats = $wpdb->get_results(‘SELECT * FROM green_voca_cat ORDER BY catID’); foreach($cats as $row) { print “catID\”>$row->name
“; } [/insert_php]
A-to-Z list

[insert_php] $cats = $wpdb->get_results(‘SELECT * FROM green_voca_cat ORDER BY catID’); foreach($cats as $row) { print ““; print ‘‘; $items = $wpdb->get_results(“SELECT * FROM green_voca WHERE catID=$row->catID AND `show`=’y’ ORDER BY title”); foreach($items as $item) { print ““; print ““; print ‘‘; } print ‘‘; } [/insert_php]

catID\”>$row->name		[ top ]
	$item->title
	$item->desc